{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "import tushare as ts  \n",
    "import pandas as pd  \n",
    "from sqlalchemy import create_engine  \n",
    "import sqlalchemy\n",
    "import mysql.connector\n",
    "try:\n",
    "    conn = mysql.connector.connect(user='diagnose_report', password='launch@1234',\n",
    "                                   host='rm-wz9v9e07mh753tk321o.mysql.rds.aliyuncs.com',\n",
    "                                   database='car_spider')\n",
    "except mysql.connector.Error as err:\n",
    "    if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:\n",
    "        print(\"Something is wrong with your user name or password\")\n",
    "    elif err.errno == errorcode.ER_BAD_DB_ERROR:\n",
    "        print(\"Database does not exist\")\n",
    "    else:\n",
    "        print(err)\n",
    "cursor = conn.cursor()\n",
    "cursor.execute(\"select notice_type,brand,curb_weight,Wheelbase,car_length,car_width,car_height,Displacement,power,replace(vin,'/r',','),car_factory from bssoz_notice_jc\")\n",
    "results = cursor.fetchall()\n",
    "jc = pd.DataFrame(results,columns=['notice_type','brand','curb_weight','Wheelbase','car_length','car_width','car_height','Displacement','power','vin','car_factory'])\n",
    "cursor.execute(\"select notice_type,brand,curb_weight,Wheelbase,car_length,car_width,car_height,Displacement,power,replace(vin,'/r',','),car_factory from bssoz_notice_suv\")\n",
    "results = cursor.fetchall()\n",
    "suv = pd.DataFrame(results,columns=['notice_type','brand','curb_weight','Wheelbase','car_length','car_width','car_height','Displacement','power','vin','car_factory'])\n",
    "suv = suv.drop([8682,8723,8857,8858,9948,9949,10086,10202,10341,10342,10343,10361,10386])\n",
    "all1 = jc.append(suv)\n",
    "cursor.execute(\"select `factory`,`brand`,`style`,`style_1`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`engine_displacement`,`最大功率[kW]` from car_price_detail\")\n",
    "results = cursor.fetchall()\n",
    "price = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "cursor.execute(\"select `厂商`,`品牌`,`车系`,`车型`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`排量(mL)`,`最大功率[kW]` from car_price_detail_stop\")\n",
    "results = cursor.fetchall()\n",
    "price2 = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "cursor.execute(\"select `厂商`,`品牌`,`车系`,`车型`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`排量(mL)`,`最大功率[kW]` from car_price_detail_stop_1\")\n",
    "results = cursor.fetchall()\n",
    "price3 = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "price = price.append(price2)\n",
    "price = price.append(price3)\n",
    "conn.commit()\n",
    "cursor.close()\n",
    "conn.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "LSG_price = price[(price['brand']=='吉利')|(price['brand']=='领克')|(price['brand']=='华普')]\n",
    "all1['3']=all1['vin'].apply(lambda x :x[:3])\n",
    "LSG = all1[(all1['3']=='L10')|(all1['3']=='L6T')|(all1['3']=='LB3')|(all1['3']=='LJU')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "LSG_price.groupby(['轴距[mm]','长×宽×高[mm]','整备质量[kg]','style'])['factory'].count().reset_index().to_csv('吉利1.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "LSG_price = LSG_price[(LSG_price['长×宽×高[mm]']!='')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>notice_type</th>\n",
       "      <th>brand_x</th>\n",
       "      <th>curb_weight</th>\n",
       "      <th>Wheelbase</th>\n",
       "      <th>car_length</th>\n",
       "      <th>car_width</th>\n",
       "      <th>car_height</th>\n",
       "      <th>Displacement</th>\n",
       "      <th>power</th>\n",
       "      <th>vin</th>\n",
       "      <th>car_factory</th>\n",
       "      <th>3</th>\n",
       "      <th>轴距[mm]</th>\n",
       "      <th>长×宽×高[mm]</th>\n",
       "      <th>brand_y</th>\n",
       "      <th>style</th>\n",
       "      <th>factory</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>HQ7142C02</td>\n",
       "      <td>帝豪</td>\n",
       "      <td>1400</td>\n",
       "      <td>2700</td>\n",
       "      <td>4725</td>\n",
       "      <td>1802</td>\n",
       "      <td>1478</td>\n",
       "      <td>1398</td>\n",
       "      <td>98</td>\n",
       "      <td>LB37824Z×××××××××</td>\n",
       "      <td>浙江豪情汽车制造有限公司</td>\n",
       "      <td>LB3</td>\n",
       "      <td>2700</td>\n",
       "      <td>4725x1802x1478</td>\n",
       "      <td>吉利</td>\n",
       "      <td>帝豪GL</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>HQ7142C02</td>\n",
       "      <td>帝豪</td>\n",
       "      <td>1400</td>\n",
       "      <td>2700</td>\n",
       "      <td>4725</td>\n",
       "      <td>1802</td>\n",
       "      <td>1478</td>\n",
       "      <td>1398</td>\n",
       "      <td>98</td>\n",
       "      <td>LB37824Z×××××××××</td>\n",
       "      <td>浙江豪情汽车制造有限公司</td>\n",
       "      <td>LB3</td>\n",
       "      <td>2700</td>\n",
       "      <td>4725x1802x1478</td>\n",
       "      <td>吉利</td>\n",
       "      <td>帝豪GL</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>MR7152L33</td>\n",
       "      <td>吉利美日</td>\n",
       "      <td>1250</td>\n",
       "      <td>2650</td>\n",
       "      <td>4632</td>\n",
       "      <td>1789</td>\n",
       "      <td>1470</td>\n",
       "      <td>1498</td>\n",
       "      <td>80</td>\n",
       "      <td>L6T7824S×××××××××</td>\n",
       "      <td>浙江吉利汽车有限公司</td>\n",
       "      <td>L6T</td>\n",
       "      <td>2650</td>\n",
       "      <td>4632x1789x1470</td>\n",
       "      <td>吉利</td>\n",
       "      <td>帝豪</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>MR7152L33</td>\n",
       "      <td>吉利美日</td>\n",
       "      <td>1250</td>\n",
       "      <td>2650</td>\n",
       "      <td>4632</td>\n",
       "      <td>1789</td>\n",
       "      <td>1470</td>\n",
       "      <td>1498</td>\n",
       "      <td>80</td>\n",
       "      <td>L6T7824S×××××××××</td>\n",
       "      <td>浙江吉利汽车有限公司</td>\n",
       "      <td>L6T</td>\n",
       "      <td>2650</td>\n",
       "      <td>4632x1789x1470</td>\n",
       "      <td>吉利</td>\n",
       "      <td>帝豪</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>MR7152L33</td>\n",
       "      <td>吉利美日</td>\n",
       "      <td>1250</td>\n",
       "      <td>2650</td>\n",
       "      <td>4632</td>\n",
       "      <td>1789</td>\n",
       "      <td>1470</td>\n",
       "      <td>1498</td>\n",
       "      <td>80</td>\n",
       "      <td>L6T7824S×××××××××</td>\n",
       "      <td>浙江吉利汽车有限公司</td>\n",
       "      <td>L6T</td>\n",
       "      <td>2650</td>\n",
       "      <td>4632x1789x1470</td>\n",
       "      <td>吉利</td>\n",
       "      <td>帝豪</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>MR7152L33</td>\n",
       "      <td>吉利美日</td>\n",
       "      <td>1250</td>\n",
       "      <td>2650</td>\n",
       "      <td>4632</td>\n",
       "      <td>1789</td>\n",
       "      <td>1470</td>\n",
       "      <td>1498</td>\n",
       "      <td>76</td>\n",
       "      <td>L6T7824S×××××××××</td>\n",
       "      <td>浙江吉利汽车有限公司</td>\n",
       "      <td>L6T</td>\n",
       "      <td>2650</td>\n",
       "      <td>4632x1789x1470</td>\n",
       "      <td>吉利</td>\n",
       "      <td>帝豪</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>MR7152C09</td>\n",
       "      <td>吉利美日</td>\n",
       "      <td>1265</td>\n",
       "      <td>2650</td>\n",
       "      <td>4632</td>\n",
       "      <td>1789</td>\n",
       "      <td>1470</td>\n",
       "      <td>1498</td>\n",
       "      <td>80</td>\n",
       "      <td>L6T7824Z×××××××××</td>\n",
       "      <td>浙江吉利汽车有限公司</td>\n",
       "      <td>L6T</td>\n",
       "      <td>2650</td>\n",
       "      <td>4632x1789x1470</td>\n",
       "      <td>吉利</td>\n",
       "      <td>帝豪</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>MR7152C09</td>\n",
       "      <td>吉利美日</td>\n",
       "      <td>1265</td>\n",
       "      <td>2650</td>\n",
       "      <td>4632</td>\n",
       "      <td>1789</td>\n",
       "      <td>1470</td>\n",
       "      <td>1498</td>\n",
       "      <td>80</td>\n",
       "      <td>L6T7824Z×××××××××</td>\n",
       "      <td>浙江吉利汽车有限公司</td>\n",
       "      <td>L6T</td>\n",
       "      <td>2650</td>\n",
       "      <td>4632x1789x1470</td>\n",
       "      <td>吉利</td>\n",
       "      <td>帝豪</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>MR7152C09</td>\n",
       "      <td>吉利美日</td>\n",
       "      <td>1265</td>\n",
       "      <td>2650</td>\n",
       "      <td>4632</td>\n",
       "      <td>1789</td>\n",
       "      <td>1470</td>\n",
       "      <td>1498</td>\n",
       "      <td>80</td>\n",
       "      <td>L6T7824Z×××××××××</td>\n",
       "      <td>浙江吉利汽车有限公司</td>\n",
       "      <td>L6T</td>\n",
       "      <td>2650</td>\n",
       "      <td>4632x1789x1470</td>\n",
       "      <td>吉利</td>\n",
       "      <td>帝豪</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>MR7152C09</td>\n",
       "      <td>吉利美日</td>\n",
       "      <td>1265</td>\n",
       "      <td>2650</td>\n",
       "      <td>4632</td>\n",
       "      <td>1789</td>\n",
       "      <td>1470</td>\n",
       "      <td>1498</td>\n",
       "      <td>76</td>\n",
       "      <td>L6T7824Z×××××××××</td>\n",
       "      <td>浙江吉利汽车有限公司</td>\n",
       "      <td>L6T</td>\n",
       "      <td>2650</td>\n",
       "      <td>4632x1789x1470</td>\n",
       "      <td>吉利</td>\n",
       "      <td>帝豪</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>MR7142C01</td>\n",
       "      <td>吉利美日</td>\n",
       "      <td>1330</td>\n",
       "      <td>2668</td>\n",
       "      <td>4465</td>\n",
       "      <td>1800</td>\n",
       "      <td>1535</td>\n",
       "      <td>1398</td>\n",
       "      <td>98</td>\n",
       "      <td>L6T7722Z×××××××××</td>\n",
       "      <td>浙江吉利汽车有限公司</td>\n",
       "      <td>L6T</td>\n",
       "      <td>2668</td>\n",
       "      <td>4465x1800x1535</td>\n",
       "      <td>吉利</td>\n",
       "      <td>远景S1</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>MR7142C01</td>\n",
       "      <td>吉利美日</td>\n",
       "      <td>1330</td>\n",
       "      <td>2668</td>\n",
       "      <td>4465</td>\n",
       "      <td>1800</td>\n",
       "      <td>1535</td>\n",
       "      <td>1398</td>\n",
       "      <td>98</td>\n",
       "      <td>L6T7722Z×××××××××</td>\n",
       "      <td>浙江吉利汽车有限公司</td>\n",
       "      <td>L6T</td>\n",
       "      <td>2668</td>\n",
       "      <td>4465x1800x1535</td>\n",
       "      <td>吉利</td>\n",
       "      <td>远景S1</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>MR7142C01</td>\n",
       "      <td>吉利美日</td>\n",
       "      <td>1330</td>\n",
       "      <td>2668</td>\n",
       "      <td>4465</td>\n",
       "      <td>1800</td>\n",
       "      <td>1535</td>\n",
       "      <td>1398</td>\n",
       "      <td>98</td>\n",
       "      <td>L6T7722Z×××××××××</td>\n",
       "      <td>浙江吉利汽车有限公司</td>\n",
       "      <td>L6T</td>\n",
       "      <td>2668</td>\n",
       "      <td>4465x1800x1535</td>\n",
       "      <td>吉利</td>\n",
       "      <td>远景S1</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>HQ7182L05</td>\n",
       "      <td>帝豪</td>\n",
       "      <td>1320</td>\n",
       "      <td>2700</td>\n",
       "      <td>4725</td>\n",
       "      <td>1802</td>\n",
       "      <td>1478</td>\n",
       "      <td>1799</td>\n",
       "      <td>98</td>\n",
       "      <td>LB37844S×××××××××</td>\n",
       "      <td>浙江豪情汽车制造有限公司</td>\n",
       "      <td>LB3</td>\n",
       "      <td>2700</td>\n",
       "      <td>4725x1802x1478</td>\n",
       "      <td>吉利</td>\n",
       "      <td>帝豪GL</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>HQ7182L05</td>\n",
       "      <td>帝豪</td>\n",
       "      <td>1320</td>\n",
       "      <td>2700</td>\n",
       "      <td>4725</td>\n",
       "      <td>1802</td>\n",
       "      <td>1478</td>\n",
       "      <td>1799</td>\n",
       "      <td>98</td>\n",
       "      <td>LB37844S×××××××××</td>\n",
       "      <td>浙江豪情汽车制造有限公司</td>\n",
       "      <td>LB3</td>\n",
       "      <td>2700</td>\n",
       "      <td>4725x1802x1478</td>\n",
       "      <td>吉利</td>\n",
       "      <td>帝豪GL</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>HQ7182L05</td>\n",
       "      <td>帝豪</td>\n",
       "      <td>1320</td>\n",
       "      <td>2700</td>\n",
       "      <td>4725</td>\n",
       "      <td>1802</td>\n",
       "      <td>1478</td>\n",
       "      <td>1799</td>\n",
       "      <td>98</td>\n",
       "      <td>LB37844S×××××××××</td>\n",
       "      <td>浙江豪情汽车制造有限公司</td>\n",
       "      <td>LB3</td>\n",
       "      <td>2700</td>\n",
       "      <td>4725x1802x1478</td>\n",
       "      <td>吉利</td>\n",
       "      <td>帝豪GL</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>HQ7182L05</td>\n",
       "      <td>帝豪</td>\n",
       "      <td>1320</td>\n",
       "      <td>2700</td>\n",
       "      <td>4725</td>\n",
       "      <td>1802</td>\n",
       "      <td>1478</td>\n",
       "      <td>1799</td>\n",
       "      <td>98</td>\n",
       "      <td>LB37844S×××××××××</td>\n",
       "      <td>浙江豪情汽车制造有限公司</td>\n",
       "      <td>LB3</td>\n",
       "      <td>2700</td>\n",
       "      <td>4725x1802x1478</td>\n",
       "      <td>吉利</td>\n",
       "      <td>帝豪GL</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>MR7243C01</td>\n",
       "      <td>吉利美日</td>\n",
       "      <td>1710</td>\n",
       "      <td>2850</td>\n",
       "      <td>4956</td>\n",
       "      <td>1861</td>\n",
       "      <td>1513</td>\n",
       "      <td>2378</td>\n",
       "      <td>119</td>\n",
       "      <td>L6T7964Z×××××××××</td>\n",
       "      <td>浙江吉利汽车有限公司</td>\n",
       "      <td>L6T</td>\n",
       "      <td>2850</td>\n",
       "      <td>4956x1861x1513</td>\n",
       "      <td>吉利</td>\n",
       "      <td>博瑞</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>HQ7142L02</td>\n",
       "      <td>帝豪</td>\n",
       "      <td>1360</td>\n",
       "      <td>2700</td>\n",
       "      <td>4725</td>\n",
       "      <td>1802</td>\n",
       "      <td>1478</td>\n",
       "      <td>1398</td>\n",
       "      <td>98</td>\n",
       "      <td>LB37824S×××××××××</td>\n",
       "      <td>浙江豪情汽车制造有限公司</td>\n",
       "      <td>LB3</td>\n",
       "      <td>2700</td>\n",
       "      <td>4725x1802x1478</td>\n",
       "      <td>吉利</td>\n",
       "      <td>帝豪GL</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>HQ7142L02</td>\n",
       "      <td>帝豪</td>\n",
       "      <td>1360</td>\n",
       "      <td>2700</td>\n",
       "      <td>4725</td>\n",
       "      <td>1802</td>\n",
       "      <td>1478</td>\n",
       "      <td>1398</td>\n",
       "      <td>98</td>\n",
       "      <td>LB37824S×××××××××</td>\n",
       "      <td>浙江豪情汽车制造有限公司</td>\n",
       "      <td>LB3</td>\n",
       "      <td>2700</td>\n",
       "      <td>4725x1802x1478</td>\n",
       "      <td>吉利</td>\n",
       "      <td>帝豪GL</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>HQ7132L06</td>\n",
       "      <td>帝豪</td>\n",
       "      <td>1360</td>\n",
       "      <td>2700</td>\n",
       "      <td>4725</td>\n",
       "      <td>1802</td>\n",
       "      <td>1478</td>\n",
       "      <td>1299</td>\n",
       "      <td>95</td>\n",
       "      <td>LB37814S×××××××××</td>\n",
       "      <td>浙江豪情汽车制造有限公司</td>\n",
       "      <td>LB3</td>\n",
       "      <td>2700</td>\n",
       "      <td>4725x1802x1478</td>\n",
       "      <td>吉利</td>\n",
       "      <td>帝豪GL</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>HQ7132L06</td>\n",
       "      <td>帝豪</td>\n",
       "      <td>1360</td>\n",
       "      <td>2700</td>\n",
       "      <td>4725</td>\n",
       "      <td>1802</td>\n",
       "      <td>1478</td>\n",
       "      <td>1299</td>\n",
       "      <td>95</td>\n",
       "      <td>LB37814S×××××××××</td>\n",
       "      <td>浙江豪情汽车制造有限公司</td>\n",
       "      <td>LB3</td>\n",
       "      <td>2700</td>\n",
       "      <td>4725x1802x1478</td>\n",
       "      <td>吉利</td>\n",
       "      <td>帝豪GL</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>HQ7182C04</td>\n",
       "      <td>帝豪</td>\n",
       "      <td>1340</td>\n",
       "      <td>2700</td>\n",
       "      <td>4725</td>\n",
       "      <td>1802</td>\n",
       "      <td>1478</td>\n",
       "      <td>1799</td>\n",
       "      <td>98</td>\n",
       "      <td>LB37844Z×××××××××</td>\n",
       "      <td>浙江豪情汽车制造有限公司</td>\n",
       "      <td>LB3</td>\n",
       "      <td>2700</td>\n",
       "      <td>4725x1802x1478</td>\n",
       "      <td>吉利</td>\n",
       "      <td>帝豪GL</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>HQ7182C04</td>\n",
       "      <td>帝豪</td>\n",
       "      <td>1340</td>\n",
       "      <td>2700</td>\n",
       "      <td>4725</td>\n",
       "      <td>1802</td>\n",
       "      <td>1478</td>\n",
       "      <td>1799</td>\n",
       "      <td>98</td>\n",
       "      <td>LB37844Z×××××××××</td>\n",
       "      <td>浙江豪情汽车制造有限公司</td>\n",
       "      <td>LB3</td>\n",
       "      <td>2700</td>\n",
       "      <td>4725x1802x1478</td>\n",
       "      <td>吉利</td>\n",
       "      <td>帝豪GL</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>HQ7182C04</td>\n",
       "      <td>帝豪</td>\n",
       "      <td>1340</td>\n",
       "      <td>2700</td>\n",
       "      <td>4725</td>\n",
       "      <td>1802</td>\n",
       "      <td>1478</td>\n",
       "      <td>1799</td>\n",
       "      <td>98</td>\n",
       "      <td>LB37844Z×××××××××</td>\n",
       "      <td>浙江豪情汽车制造有限公司</td>\n",
       "      <td>LB3</td>\n",
       "      <td>2700</td>\n",
       "      <td>4725x1802x1478</td>\n",
       "      <td>吉利</td>\n",
       "      <td>帝豪GL</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>HQ7182C04</td>\n",
       "      <td>帝豪</td>\n",
       "      <td>1340</td>\n",
       "      <td>2700</td>\n",
       "      <td>4725</td>\n",
       "      <td>1802</td>\n",
       "      <td>1478</td>\n",
       "      <td>1799</td>\n",
       "      <td>98</td>\n",
       "      <td>LB37844Z×××××××××</td>\n",
       "      <td>浙江豪情汽车制造有限公司</td>\n",
       "      <td>LB3</td>\n",
       "      <td>2700</td>\n",
       "      <td>4725x1802x1478</td>\n",
       "      <td>吉利</td>\n",
       "      <td>帝豪GL</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>JL7151L15</td>\n",
       "      <td>吉利</td>\n",
       "      <td>1180</td>\n",
       "      <td>2480</td>\n",
       "      <td>4005</td>\n",
       "      <td>1760</td>\n",
       "      <td>1575</td>\n",
       "      <td>1498</td>\n",
       "      <td>75</td>\n",
       "      <td>LB37522S×××××××××</td>\n",
       "      <td>浙江豪情汽车制造有限公司</td>\n",
       "      <td>LB3</td>\n",
       "      <td>2480</td>\n",
       "      <td>4005x1760x1575</td>\n",
       "      <td>吉利</td>\n",
       "      <td>远景X3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>JL7151L15</td>\n",
       "      <td>吉利</td>\n",
       "      <td>1180</td>\n",
       "      <td>2480</td>\n",
       "      <td>4005</td>\n",
       "      <td>1760</td>\n",
       "      <td>1575</td>\n",
       "      <td>1498</td>\n",
       "      <td>75</td>\n",
       "      <td>LB37522S×××××××××</td>\n",
       "      <td>浙江豪情汽车制造有限公司</td>\n",
       "      <td>LB3</td>\n",
       "      <td>2480</td>\n",
       "      <td>4005x1760x1575</td>\n",
       "      <td>吉利</td>\n",
       "      <td>远景X3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>JL7152C11</td>\n",
       "      <td>帝豪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2615</td>\n",
       "      <td>4599</td>\n",
       "      <td>1747</td>\n",
       "      <td>1482</td>\n",
       "      <td>1498</td>\n",
       "      <td>80</td>\n",
       "      <td>LB37724Z×××××××××</td>\n",
       "      <td>浙江豪情汽车制造有限公司</td>\n",
       "      <td>LB3</td>\n",
       "      <td>2615</td>\n",
       "      <td>4599x1747x1482</td>\n",
       "      <td>吉利</td>\n",
       "      <td>远景</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>JL7152L23</td>\n",
       "      <td>帝豪</td>\n",
       "      <td>1210</td>\n",
       "      <td>2615</td>\n",
       "      <td>4599</td>\n",
       "      <td>1747</td>\n",
       "      <td>1482</td>\n",
       "      <td>1498</td>\n",
       "      <td>80</td>\n",
       "      <td>LB37724S×××××××××</td>\n",
       "      <td>浙江豪情汽车制造有限公司</td>\n",
       "      <td>LB3</td>\n",
       "      <td>2615</td>\n",
       "      <td>4599x1747x1482</td>\n",
       "      <td>吉利</td>\n",
       "      <td>远景</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>664</th>\n",
       "      <td>HQ6453C04</td>\n",
       "      <td>吉利</td>\n",
       "      <td>1745</td>\n",
       "      <td>2670</td>\n",
       "      <td>4519</td>\n",
       "      <td>1831</td>\n",
       "      <td>1694</td>\n",
       "      <td>1799</td>\n",
       "      <td>135</td>\n",
       "      <td>LB37742D×××××××××</td>\n",
       "      <td>浙江豪情汽车制造有限公司</td>\n",
       "      <td>LB3</td>\n",
       "      <td>2670</td>\n",
       "      <td>4519x1831x1694</td>\n",
       "      <td>吉利</td>\n",
       "      <td>博越</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>665</th>\n",
       "      <td>HQ6453C04</td>\n",
       "      <td>吉利</td>\n",
       "      <td>1745</td>\n",
       "      <td>2670</td>\n",
       "      <td>4519</td>\n",
       "      <td>1831</td>\n",
       "      <td>1694</td>\n",
       "      <td>1799</td>\n",
       "      <td>135</td>\n",
       "      <td>LB37742D×××××××××</td>\n",
       "      <td>浙江豪情汽车制造有限公司</td>\n",
       "      <td>LB3</td>\n",
       "      <td>2670</td>\n",
       "      <td>4519x1831x1694</td>\n",
       "      <td>吉利</td>\n",
       "      <td>博越</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>666</th>\n",
       "      <td>HQ6453C04</td>\n",
       "      <td>吉利</td>\n",
       "      <td>1745</td>\n",
       "      <td>2670</td>\n",
       "      <td>4519</td>\n",
       "      <td>1831</td>\n",
       "      <td>1694</td>\n",
       "      <td>1799</td>\n",
       "      <td>135</td>\n",
       "      <td>LB37742D×××××××××</td>\n",
       "      <td>浙江豪情汽车制造有限公司</td>\n",
       "      <td>LB3</td>\n",
       "      <td>2670</td>\n",
       "      <td>4519x1831x1694</td>\n",
       "      <td>吉利</td>\n",
       "      <td>博越</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>667</th>\n",
       "      <td>HQ6453C04</td>\n",
       "      <td>吉利</td>\n",
       "      <td>1745</td>\n",
       "      <td>2670</td>\n",
       "      <td>4519</td>\n",
       "      <td>1831</td>\n",
       "      <td>1694</td>\n",
       "      <td>1799</td>\n",
       "      <td>135</td>\n",
       "      <td>LB37742D×××××××××</td>\n",
       "      <td>浙江豪情汽车制造有限公司</td>\n",
       "      <td>LB3</td>\n",
       "      <td>2670</td>\n",
       "      <td>4519x1831x1694</td>\n",
       "      <td>吉利</td>\n",
       "      <td>博越</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>668</th>\n",
       "      <td>HQ6453L02</td>\n",
       "      <td>吉利</td>\n",
       "      <td>1630</td>\n",
       "      <td>2670</td>\n",
       "      <td>4519</td>\n",
       "      <td>1831</td>\n",
       "      <td>1694</td>\n",
       "      <td>1799</td>\n",
       "      <td>120</td>\n",
       "      <td>LB37742S×××××××××</td>\n",
       "      <td>浙江豪情汽车制造有限公司</td>\n",
       "      <td>LB3</td>\n",
       "      <td>2670</td>\n",
       "      <td>4519x1831x1694</td>\n",
       "      <td>吉利</td>\n",
       "      <td>博越</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>669</th>\n",
       "      <td>HQ6453L02</td>\n",
       "      <td>吉利</td>\n",
       "      <td>1630</td>\n",
       "      <td>2670</td>\n",
       "      <td>4519</td>\n",
       "      <td>1831</td>\n",
       "      <td>1694</td>\n",
       "      <td>1799</td>\n",
       "      <td>120</td>\n",
       "      <td>LB37742S×××××××××</td>\n",
       "      <td>浙江豪情汽车制造有限公司</td>\n",
       "      <td>LB3</td>\n",
       "      <td>2670</td>\n",
       "      <td>4519x1831x1694</td>\n",
       "      <td>吉利</td>\n",
       "      <td>博越</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>670</th>\n",
       "      <td>HQ6453L02</td>\n",
       "      <td>吉利</td>\n",
       "      <td>1630</td>\n",
       "      <td>2670</td>\n",
       "      <td>4519</td>\n",
       "      <td>1831</td>\n",
       "      <td>1694</td>\n",
       "      <td>1799</td>\n",
       "      <td>120</td>\n",
       "      <td>LB37742S×××××××××</td>\n",
       "      <td>浙江豪情汽车制造有限公司</td>\n",
       "      <td>LB3</td>\n",
       "      <td>2670</td>\n",
       "      <td>4519x1831x1694</td>\n",
       "      <td>吉利</td>\n",
       "      <td>博越</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>671</th>\n",
       "      <td>HQ6453L02</td>\n",
       "      <td>吉利</td>\n",
       "      <td>1630</td>\n",
       "      <td>2670</td>\n",
       "      <td>4519</td>\n",
       "      <td>1831</td>\n",
       "      <td>1694</td>\n",
       "      <td>1799</td>\n",
       "      <td>120</td>\n",
       "      <td>LB37742S×××××××××</td>\n",
       "      <td>浙江豪情汽车制造有限公司</td>\n",
       "      <td>LB3</td>\n",
       "      <td>2670</td>\n",
       "      <td>4519x1831x1694</td>\n",
       "      <td>吉利</td>\n",
       "      <td>博越</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>672</th>\n",
       "      <td>HQ6453L01</td>\n",
       "      <td>吉利</td>\n",
       "      <td>1565</td>\n",
       "      <td>2670</td>\n",
       "      <td>4519</td>\n",
       "      <td>1831</td>\n",
       "      <td>1694</td>\n",
       "      <td>1997</td>\n",
       "      <td>104</td>\n",
       "      <td>LB37752S×××××××××</td>\n",
       "      <td>浙江豪情汽车制造有限公司</td>\n",
       "      <td>LB3</td>\n",
       "      <td>2670</td>\n",
       "      <td>4519x1831x1694</td>\n",
       "      <td>吉利</td>\n",
       "      <td>博越</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>673</th>\n",
       "      <td>HQ6453L01</td>\n",
       "      <td>吉利</td>\n",
       "      <td>1565</td>\n",
       "      <td>2670</td>\n",
       "      <td>4519</td>\n",
       "      <td>1831</td>\n",
       "      <td>1694</td>\n",
       "      <td>1997</td>\n",
       "      <td>104</td>\n",
       "      <td>LB37752S×××××××××</td>\n",
       "      <td>浙江豪情汽车制造有限公司</td>\n",
       "      <td>LB3</td>\n",
       "      <td>2670</td>\n",
       "      <td>4519x1831x1694</td>\n",
       "      <td>吉利</td>\n",
       "      <td>博越</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>674</th>\n",
       "      <td>HQ6453L01</td>\n",
       "      <td>吉利</td>\n",
       "      <td>1565</td>\n",
       "      <td>2670</td>\n",
       "      <td>4519</td>\n",
       "      <td>1831</td>\n",
       "      <td>1694</td>\n",
       "      <td>1997</td>\n",
       "      <td>104</td>\n",
       "      <td>LB37752S×××××××××</td>\n",
       "      <td>浙江豪情汽车制造有限公司</td>\n",
       "      <td>LB3</td>\n",
       "      <td>2670</td>\n",
       "      <td>4519x1831x1694</td>\n",
       "      <td>吉利</td>\n",
       "      <td>博越</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>675</th>\n",
       "      <td>HQ6453L01</td>\n",
       "      <td>吉利</td>\n",
       "      <td>1565</td>\n",
       "      <td>2670</td>\n",
       "      <td>4519</td>\n",
       "      <td>1831</td>\n",
       "      <td>1694</td>\n",
       "      <td>1997</td>\n",
       "      <td>104</td>\n",
       "      <td>LB37752S×××××××××</td>\n",
       "      <td>浙江豪情汽车制造有限公司</td>\n",
       "      <td>LB3</td>\n",
       "      <td>2670</td>\n",
       "      <td>4519x1831x1694</td>\n",
       "      <td>吉利</td>\n",
       "      <td>博越</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>676</th>\n",
       "      <td>HQ6453L01</td>\n",
       "      <td>吉利</td>\n",
       "      <td>1565</td>\n",
       "      <td>2670</td>\n",
       "      <td>4519</td>\n",
       "      <td>1831</td>\n",
       "      <td>1694</td>\n",
       "      <td>1997</td>\n",
       "      <td>104</td>\n",
       "      <td>LB37752S×××××××××</td>\n",
       "      <td>浙江豪情汽车制造有限公司</td>\n",
       "      <td>LB3</td>\n",
       "      <td>2670</td>\n",
       "      <td>4519x1831x1694</td>\n",
       "      <td>吉利</td>\n",
       "      <td>博越</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>677</th>\n",
       "      <td>MR6453C10</td>\n",
       "      <td>领克</td>\n",
       "      <td>1632</td>\n",
       "      <td>2734</td>\n",
       "      <td>4512</td>\n",
       "      <td>1857</td>\n",
       "      <td>1673</td>\n",
       "      <td>1969</td>\n",
       "      <td>140</td>\n",
       "      <td>L6T7752Z×××××××××</td>\n",
       "      <td>浙江吉利汽车有限公司</td>\n",
       "      <td>L6T</td>\n",
       "      <td>2734</td>\n",
       "      <td>4512x1857x1673</td>\n",
       "      <td>领克</td>\n",
       "      <td>领克01</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>678</th>\n",
       "      <td>JL6453C05</td>\n",
       "      <td>帝豪</td>\n",
       "      <td>1505</td>\n",
       "      <td>2661</td>\n",
       "      <td>4500</td>\n",
       "      <td>1834</td>\n",
       "      <td>1707</td>\n",
       "      <td>1299</td>\n",
       "      <td>98</td>\n",
       "      <td>LB37712Z×××××××××</td>\n",
       "      <td>浙江豪情汽车制造有限公司</td>\n",
       "      <td>LB3</td>\n",
       "      <td>2661</td>\n",
       "      <td>4500x1834x1707</td>\n",
       "      <td>吉利</td>\n",
       "      <td>远景SUV</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>679</th>\n",
       "      <td>JL6453C05</td>\n",
       "      <td>帝豪</td>\n",
       "      <td>1505</td>\n",
       "      <td>2661</td>\n",
       "      <td>4500</td>\n",
       "      <td>1834</td>\n",
       "      <td>1707</td>\n",
       "      <td>1299</td>\n",
       "      <td>98</td>\n",
       "      <td>LB37712Z×××××××××</td>\n",
       "      <td>浙江豪情汽车制造有限公司</td>\n",
       "      <td>LB3</td>\n",
       "      <td>2661</td>\n",
       "      <td>4500x1834x1707</td>\n",
       "      <td>吉利</td>\n",
       "      <td>远景SUV</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>680</th>\n",
       "      <td>JL6453C05</td>\n",
       "      <td>帝豪</td>\n",
       "      <td>1505</td>\n",
       "      <td>2661</td>\n",
       "      <td>4500</td>\n",
       "      <td>1834</td>\n",
       "      <td>1707</td>\n",
       "      <td>1299</td>\n",
       "      <td>98</td>\n",
       "      <td>LB37712Z×××××××××</td>\n",
       "      <td>浙江豪情汽车制造有限公司</td>\n",
       "      <td>LB3</td>\n",
       "      <td>2661</td>\n",
       "      <td>4500x1834x1707</td>\n",
       "      <td>吉利</td>\n",
       "      <td>远景SUV</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>681</th>\n",
       "      <td>JL6453C05</td>\n",
       "      <td>帝豪</td>\n",
       "      <td>1505</td>\n",
       "      <td>2661</td>\n",
       "      <td>4500</td>\n",
       "      <td>1834</td>\n",
       "      <td>1707</td>\n",
       "      <td>1299</td>\n",
       "      <td>98</td>\n",
       "      <td>LB37712Z×××××××××</td>\n",
       "      <td>浙江豪情汽车制造有限公司</td>\n",
       "      <td>LB3</td>\n",
       "      <td>2661</td>\n",
       "      <td>4500x1834x1707</td>\n",
       "      <td>吉利</td>\n",
       "      <td>远景SUV</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>682</th>\n",
       "      <td>JL6453C05</td>\n",
       "      <td>帝豪</td>\n",
       "      <td>1505</td>\n",
       "      <td>2661</td>\n",
       "      <td>4500</td>\n",
       "      <td>1834</td>\n",
       "      <td>1707</td>\n",
       "      <td>1299</td>\n",
       "      <td>98</td>\n",
       "      <td>LB37712Z×××××××××</td>\n",
       "      <td>浙江豪情汽车制造有限公司</td>\n",
       "      <td>LB3</td>\n",
       "      <td>2661</td>\n",
       "      <td>4500x1834x1707</td>\n",
       "      <td>吉利</td>\n",
       "      <td>远景SUV</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>683</th>\n",
       "      <td>JL6453C05</td>\n",
       "      <td>帝豪</td>\n",
       "      <td>1505</td>\n",
       "      <td>2661</td>\n",
       "      <td>4500</td>\n",
       "      <td>1834</td>\n",
       "      <td>1707</td>\n",
       "      <td>1299</td>\n",
       "      <td>98</td>\n",
       "      <td>LB37712Z×××××××××</td>\n",
       "      <td>浙江豪情汽车制造有限公司</td>\n",
       "      <td>LB3</td>\n",
       "      <td>2661</td>\n",
       "      <td>4500x1834x1707</td>\n",
       "      <td>吉利</td>\n",
       "      <td>远景SUV</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>684</th>\n",
       "      <td>JL6453C12</td>\n",
       "      <td>帝豪</td>\n",
       "      <td>1544</td>\n",
       "      <td>2661</td>\n",
       "      <td>4500</td>\n",
       "      <td>1834</td>\n",
       "      <td>1707</td>\n",
       "      <td>1398</td>\n",
       "      <td>98</td>\n",
       "      <td>LB37722Z×××××××××</td>\n",
       "      <td>浙江豪情汽车制造有限公司</td>\n",
       "      <td>LB3</td>\n",
       "      <td>2661</td>\n",
       "      <td>4500x1834x1707</td>\n",
       "      <td>吉利</td>\n",
       "      <td>远景SUV</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>685</th>\n",
       "      <td>JL6453C12</td>\n",
       "      <td>帝豪</td>\n",
       "      <td>1544</td>\n",
       "      <td>2661</td>\n",
       "      <td>4500</td>\n",
       "      <td>1834</td>\n",
       "      <td>1707</td>\n",
       "      <td>1398</td>\n",
       "      <td>98</td>\n",
       "      <td>LB37722Z×××××××××</td>\n",
       "      <td>浙江豪情汽车制造有限公司</td>\n",
       "      <td>LB3</td>\n",
       "      <td>2661</td>\n",
       "      <td>4500x1834x1707</td>\n",
       "      <td>吉利</td>\n",
       "      <td>远景SUV</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>686</th>\n",
       "      <td>HQ6453C03</td>\n",
       "      <td>吉利</td>\n",
       "      <td>1670</td>\n",
       "      <td>2670</td>\n",
       "      <td>4519</td>\n",
       "      <td>1831</td>\n",
       "      <td>1694</td>\n",
       "      <td>1799</td>\n",
       "      <td>135</td>\n",
       "      <td>LB37742Z×××××××××</td>\n",
       "      <td>浙江豪情汽车制造有限公司</td>\n",
       "      <td>LB3</td>\n",
       "      <td>2670</td>\n",
       "      <td>4519x1831x1694</td>\n",
       "      <td>吉利</td>\n",
       "      <td>博越</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>687</th>\n",
       "      <td>MR6453C04</td>\n",
       "      <td>吉利美日</td>\n",
       "      <td>1670</td>\n",
       "      <td>2670</td>\n",
       "      <td>4519</td>\n",
       "      <td>1831</td>\n",
       "      <td>1694</td>\n",
       "      <td>1799</td>\n",
       "      <td>135</td>\n",
       "      <td>L6T7742Z×××××××××</td>\n",
       "      <td>浙江吉利汽车有限公司</td>\n",
       "      <td>L6T</td>\n",
       "      <td>2670</td>\n",
       "      <td>4519x1831x1694</td>\n",
       "      <td>吉利</td>\n",
       "      <td>博越</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>688</th>\n",
       "      <td>MR6453C04</td>\n",
       "      <td>吉利美日</td>\n",
       "      <td>1670</td>\n",
       "      <td>2670</td>\n",
       "      <td>4519</td>\n",
       "      <td>1831</td>\n",
       "      <td>1694</td>\n",
       "      <td>1799</td>\n",
       "      <td>135</td>\n",
       "      <td>L6T7742Z×××××××××</td>\n",
       "      <td>浙江吉利汽车有限公司</td>\n",
       "      <td>L6T</td>\n",
       "      <td>2670</td>\n",
       "      <td>4519x1831x1694</td>\n",
       "      <td>吉利</td>\n",
       "      <td>博越</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>689</th>\n",
       "      <td>MR6453C04</td>\n",
       "      <td>吉利美日</td>\n",
       "      <td>1670</td>\n",
       "      <td>2670</td>\n",
       "      <td>4519</td>\n",
       "      <td>1831</td>\n",
       "      <td>1694</td>\n",
       "      <td>1799</td>\n",
       "      <td>135</td>\n",
       "      <td>L6T7742Z×××××××××</td>\n",
       "      <td>浙江吉利汽车有限公司</td>\n",
       "      <td>L6T</td>\n",
       "      <td>2670</td>\n",
       "      <td>4519x1831x1694</td>\n",
       "      <td>吉利</td>\n",
       "      <td>博越</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>690</th>\n",
       "      <td>MR6453C04</td>\n",
       "      <td>吉利美日</td>\n",
       "      <td>1670</td>\n",
       "      <td>2670</td>\n",
       "      <td>4519</td>\n",
       "      <td>1831</td>\n",
       "      <td>1694</td>\n",
       "      <td>1799</td>\n",
       "      <td>135</td>\n",
       "      <td>L6T7742Z×××××××××</td>\n",
       "      <td>浙江吉利汽车有限公司</td>\n",
       "      <td>L6T</td>\n",
       "      <td>2670</td>\n",
       "      <td>4519x1831x1694</td>\n",
       "      <td>吉利</td>\n",
       "      <td>博越</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>691</th>\n",
       "      <td>JL6483L01</td>\n",
       "      <td>吉利</td>\n",
       "      <td>1773</td>\n",
       "      <td>2804</td>\n",
       "      <td>4844</td>\n",
       "      <td>1884</td>\n",
       "      <td>1762</td>\n",
       "      <td>2378</td>\n",
       "      <td>119</td>\n",
       "      <td>LB37962C×××××××××</td>\n",
       "      <td>浙江豪情汽车制造有限公司</td>\n",
       "      <td>LB3</td>\n",
       "      <td>2804</td>\n",
       "      <td>4844x1884x1762</td>\n",
       "      <td>吉利</td>\n",
       "      <td>豪情SUV</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>692</th>\n",
       "      <td>JL6483L01</td>\n",
       "      <td>吉利</td>\n",
       "      <td>1773</td>\n",
       "      <td>2804</td>\n",
       "      <td>4844</td>\n",
       "      <td>1884</td>\n",
       "      <td>1762</td>\n",
       "      <td>2378</td>\n",
       "      <td>119</td>\n",
       "      <td>LB37962C×××××××××</td>\n",
       "      <td>浙江豪情汽车制造有限公司</td>\n",
       "      <td>LB3</td>\n",
       "      <td>2804</td>\n",
       "      <td>4844x1884x1762</td>\n",
       "      <td>吉利</td>\n",
       "      <td>豪情SUV</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>693</th>\n",
       "      <td>RX6483L05</td>\n",
       "      <td>帝豪</td>\n",
       "      <td>1773</td>\n",
       "      <td>2804</td>\n",
       "      <td>4844</td>\n",
       "      <td>1884</td>\n",
       "      <td>1762</td>\n",
       "      <td>2378</td>\n",
       "      <td>119</td>\n",
       "      <td>L108DBC5×××××××××</td>\n",
       "      <td>成都新大地汽车有限责任公司</td>\n",
       "      <td>L10</td>\n",
       "      <td>2804</td>\n",
       "      <td>4844x1884x1762</td>\n",
       "      <td>吉利</td>\n",
       "      <td>豪情SUV</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>694 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    notice_type brand_x curb_weight Wheelbase car_length car_width car_height  \\\n",
       "0     HQ7142C02      帝豪        1400      2700       4725      1802       1478   \n",
       "1     HQ7142C02      帝豪        1400      2700       4725      1802       1478   \n",
       "2     MR7152L33    吉利美日        1250      2650       4632      1789       1470   \n",
       "3     MR7152L33    吉利美日        1250      2650       4632      1789       1470   \n",
       "4     MR7152L33    吉利美日        1250      2650       4632      1789       1470   \n",
       "5     MR7152L33    吉利美日        1250      2650       4632      1789       1470   \n",
       "6     MR7152C09    吉利美日        1265      2650       4632      1789       1470   \n",
       "7     MR7152C09    吉利美日        1265      2650       4632      1789       1470   \n",
       "8     MR7152C09    吉利美日        1265      2650       4632      1789       1470   \n",
       "9     MR7152C09    吉利美日        1265      2650       4632      1789       1470   \n",
       "10    MR7142C01    吉利美日        1330      2668       4465      1800       1535   \n",
       "11    MR7142C01    吉利美日        1330      2668       4465      1800       1535   \n",
       "12    MR7142C01    吉利美日        1330      2668       4465      1800       1535   \n",
       "13    HQ7182L05      帝豪        1320      2700       4725      1802       1478   \n",
       "14    HQ7182L05      帝豪        1320      2700       4725      1802       1478   \n",
       "15    HQ7182L05      帝豪        1320      2700       4725      1802       1478   \n",
       "16    HQ7182L05      帝豪        1320      2700       4725      1802       1478   \n",
       "17    MR7243C01    吉利美日        1710      2850       4956      1861       1513   \n",
       "18    HQ7142L02      帝豪        1360      2700       4725      1802       1478   \n",
       "19    HQ7142L02      帝豪        1360      2700       4725      1802       1478   \n",
       "20    HQ7132L06      帝豪        1360      2700       4725      1802       1478   \n",
       "21    HQ7132L06      帝豪        1360      2700       4725      1802       1478   \n",
       "22    HQ7182C04      帝豪        1340      2700       4725      1802       1478   \n",
       "23    HQ7182C04      帝豪        1340      2700       4725      1802       1478   \n",
       "24    HQ7182C04      帝豪        1340      2700       4725      1802       1478   \n",
       "25    HQ7182C04      帝豪        1340      2700       4725      1802       1478   \n",
       "26    JL7151L15      吉利        1180      2480       4005      1760       1575   \n",
       "27    JL7151L15      吉利        1180      2480       4005      1760       1575   \n",
       "28    JL7152C11      帝豪        1210      2615       4599      1747       1482   \n",
       "29    JL7152L23      帝豪        1210      2615       4599      1747       1482   \n",
       "..          ...     ...         ...       ...        ...       ...        ...   \n",
       "664   HQ6453C04      吉利        1745      2670       4519      1831       1694   \n",
       "665   HQ6453C04      吉利        1745      2670       4519      1831       1694   \n",
       "666   HQ6453C04      吉利        1745      2670       4519      1831       1694   \n",
       "667   HQ6453C04      吉利        1745      2670       4519      1831       1694   \n",
       "668   HQ6453L02      吉利        1630      2670       4519      1831       1694   \n",
       "669   HQ6453L02      吉利        1630      2670       4519      1831       1694   \n",
       "670   HQ6453L02      吉利        1630      2670       4519      1831       1694   \n",
       "671   HQ6453L02      吉利        1630      2670       4519      1831       1694   \n",
       "672   HQ6453L01      吉利        1565      2670       4519      1831       1694   \n",
       "673   HQ6453L01      吉利        1565      2670       4519      1831       1694   \n",
       "674   HQ6453L01      吉利        1565      2670       4519      1831       1694   \n",
       "675   HQ6453L01      吉利        1565      2670       4519      1831       1694   \n",
       "676   HQ6453L01      吉利        1565      2670       4519      1831       1694   \n",
       "677   MR6453C10      领克        1632      2734       4512      1857       1673   \n",
       "678   JL6453C05      帝豪        1505      2661       4500      1834       1707   \n",
       "679   JL6453C05      帝豪        1505      2661       4500      1834       1707   \n",
       "680   JL6453C05      帝豪        1505      2661       4500      1834       1707   \n",
       "681   JL6453C05      帝豪        1505      2661       4500      1834       1707   \n",
       "682   JL6453C05      帝豪        1505      2661       4500      1834       1707   \n",
       "683   JL6453C05      帝豪        1505      2661       4500      1834       1707   \n",
       "684   JL6453C12      帝豪        1544      2661       4500      1834       1707   \n",
       "685   JL6453C12      帝豪        1544      2661       4500      1834       1707   \n",
       "686   HQ6453C03      吉利        1670      2670       4519      1831       1694   \n",
       "687   MR6453C04    吉利美日        1670      2670       4519      1831       1694   \n",
       "688   MR6453C04    吉利美日        1670      2670       4519      1831       1694   \n",
       "689   MR6453C04    吉利美日        1670      2670       4519      1831       1694   \n",
       "690   MR6453C04    吉利美日        1670      2670       4519      1831       1694   \n",
       "691   JL6483L01      吉利        1773      2804       4844      1884       1762   \n",
       "692   JL6483L01      吉利        1773      2804       4844      1884       1762   \n",
       "693   RX6483L05      帝豪        1773      2804       4844      1884       1762   \n",
       "\n",
       "    Displacement power                vin    car_factory    3 轴距[mm]  \\\n",
       "0           1398    98  LB37824Z×××××××××   浙江豪情汽车制造有限公司  LB3   2700   \n",
       "1           1398    98  LB37824Z×××××××××   浙江豪情汽车制造有限公司  LB3   2700   \n",
       "2           1498    80  L6T7824S×××××××××     浙江吉利汽车有限公司  L6T   2650   \n",
       "3           1498    80  L6T7824S×××××××××     浙江吉利汽车有限公司  L6T   2650   \n",
       "4           1498    80  L6T7824S×××××××××     浙江吉利汽车有限公司  L6T   2650   \n",
       "5           1498    76  L6T7824S×××××××××     浙江吉利汽车有限公司  L6T   2650   \n",
       "6           1498    80  L6T7824Z×××××××××     浙江吉利汽车有限公司  L6T   2650   \n",
       "7           1498    80  L6T7824Z×××××××××     浙江吉利汽车有限公司  L6T   2650   \n",
       "8           1498    80  L6T7824Z×××××××××     浙江吉利汽车有限公司  L6T   2650   \n",
       "9           1498    76  L6T7824Z×××××××××     浙江吉利汽车有限公司  L6T   2650   \n",
       "10          1398    98  L6T7722Z×××××××××     浙江吉利汽车有限公司  L6T   2668   \n",
       "11          1398    98  L6T7722Z×××××××××     浙江吉利汽车有限公司  L6T   2668   \n",
       "12          1398    98  L6T7722Z×××××××××     浙江吉利汽车有限公司  L6T   2668   \n",
       "13          1799    98  LB37844S×××××××××   浙江豪情汽车制造有限公司  LB3   2700   \n",
       "14          1799    98  LB37844S×××××××××   浙江豪情汽车制造有限公司  LB3   2700   \n",
       "15          1799    98  LB37844S×××××××××   浙江豪情汽车制造有限公司  LB3   2700   \n",
       "16          1799    98  LB37844S×××××××××   浙江豪情汽车制造有限公司  LB3   2700   \n",
       "17          2378   119  L6T7964Z×××××××××     浙江吉利汽车有限公司  L6T   2850   \n",
       "18          1398    98  LB37824S×××××××××   浙江豪情汽车制造有限公司  LB3   2700   \n",
       "19          1398    98  LB37824S×××××××××   浙江豪情汽车制造有限公司  LB3   2700   \n",
       "20          1299    95  LB37814S×××××××××   浙江豪情汽车制造有限公司  LB3   2700   \n",
       "21          1299    95  LB37814S×××××××××   浙江豪情汽车制造有限公司  LB3   2700   \n",
       "22          1799    98  LB37844Z×××××××××   浙江豪情汽车制造有限公司  LB3   2700   \n",
       "23          1799    98  LB37844Z×××××××××   浙江豪情汽车制造有限公司  LB3   2700   \n",
       "24          1799    98  LB37844Z×××××××××   浙江豪情汽车制造有限公司  LB3   2700   \n",
       "25          1799    98  LB37844Z×××××××××   浙江豪情汽车制造有限公司  LB3   2700   \n",
       "26          1498    75  LB37522S×××××××××   浙江豪情汽车制造有限公司  LB3   2480   \n",
       "27          1498    75  LB37522S×××××××××   浙江豪情汽车制造有限公司  LB3   2480   \n",
       "28          1498    80  LB37724Z×××××××××   浙江豪情汽车制造有限公司  LB3   2615   \n",
       "29          1498    80  LB37724S×××××××××   浙江豪情汽车制造有限公司  LB3   2615   \n",
       "..           ...   ...                ...            ...  ...    ...   \n",
       "664         1799   135  LB37742D×××××××××   浙江豪情汽车制造有限公司  LB3   2670   \n",
       "665         1799   135  LB37742D×××××××××   浙江豪情汽车制造有限公司  LB3   2670   \n",
       "666         1799   135  LB37742D×××××××××   浙江豪情汽车制造有限公司  LB3   2670   \n",
       "667         1799   135  LB37742D×××××××××   浙江豪情汽车制造有限公司  LB3   2670   \n",
       "668         1799   120  LB37742S×××××××××   浙江豪情汽车制造有限公司  LB3   2670   \n",
       "669         1799   120  LB37742S×××××××××   浙江豪情汽车制造有限公司  LB3   2670   \n",
       "670         1799   120  LB37742S×××××××××   浙江豪情汽车制造有限公司  LB3   2670   \n",
       "671         1799   120  LB37742S×××××××××   浙江豪情汽车制造有限公司  LB3   2670   \n",
       "672         1997   104  LB37752S×××××××××   浙江豪情汽车制造有限公司  LB3   2670   \n",
       "673         1997   104  LB37752S×××××××××   浙江豪情汽车制造有限公司  LB3   2670   \n",
       "674         1997   104  LB37752S×××××××××   浙江豪情汽车制造有限公司  LB3   2670   \n",
       "675         1997   104  LB37752S×××××××××   浙江豪情汽车制造有限公司  LB3   2670   \n",
       "676         1997   104  LB37752S×××××××××   浙江豪情汽车制造有限公司  LB3   2670   \n",
       "677         1969   140  L6T7752Z×××××××××     浙江吉利汽车有限公司  L6T   2734   \n",
       "678         1299    98  LB37712Z×××××××××   浙江豪情汽车制造有限公司  LB3   2661   \n",
       "679         1299    98  LB37712Z×××××××××   浙江豪情汽车制造有限公司  LB3   2661   \n",
       "680         1299    98  LB37712Z×××××××××   浙江豪情汽车制造有限公司  LB3   2661   \n",
       "681         1299    98  LB37712Z×××××××××   浙江豪情汽车制造有限公司  LB3   2661   \n",
       "682         1299    98  LB37712Z×××××××××   浙江豪情汽车制造有限公司  LB3   2661   \n",
       "683         1299    98  LB37712Z×××××××××   浙江豪情汽车制造有限公司  LB3   2661   \n",
       "684         1398    98  LB37722Z×××××××××   浙江豪情汽车制造有限公司  LB3   2661   \n",
       "685         1398    98  LB37722Z×××××××××   浙江豪情汽车制造有限公司  LB3   2661   \n",
       "686         1799   135  LB37742Z×××××××××   浙江豪情汽车制造有限公司  LB3   2670   \n",
       "687         1799   135  L6T7742Z×××××××××     浙江吉利汽车有限公司  L6T   2670   \n",
       "688         1799   135  L6T7742Z×××××××××     浙江吉利汽车有限公司  L6T   2670   \n",
       "689         1799   135  L6T7742Z×××××××××     浙江吉利汽车有限公司  L6T   2670   \n",
       "690         1799   135  L6T7742Z×××××××××     浙江吉利汽车有限公司  L6T   2670   \n",
       "691         2378   119  LB37962C×××××××××   浙江豪情汽车制造有限公司  LB3   2804   \n",
       "692         2378   119  LB37962C×××××××××   浙江豪情汽车制造有限公司  LB3   2804   \n",
       "693         2378   119  L108DBC5×××××××××  成都新大地汽车有限责任公司  L10   2804   \n",
       "\n",
       "          长×宽×高[mm] brand_y  style  factory  \n",
       "0    4725x1802x1478      吉利   帝豪GL        3  \n",
       "1    4725x1802x1478      吉利   帝豪GL        3  \n",
       "2    4632x1789x1470      吉利     帝豪        3  \n",
       "3    4632x1789x1470      吉利     帝豪        3  \n",
       "4    4632x1789x1470      吉利     帝豪        3  \n",
       "5    4632x1789x1470      吉利     帝豪        3  \n",
       "6    4632x1789x1470      吉利     帝豪        3  \n",
       "7    4632x1789x1470      吉利     帝豪        3  \n",
       "8    4632x1789x1470      吉利     帝豪        3  \n",
       "9    4632x1789x1470      吉利     帝豪        3  \n",
       "10   4465x1800x1535      吉利   远景S1        3  \n",
       "11   4465x1800x1535      吉利   远景S1        3  \n",
       "12   4465x1800x1535      吉利   远景S1        3  \n",
       "13   4725x1802x1478      吉利   帝豪GL        4  \n",
       "14   4725x1802x1478      吉利   帝豪GL        4  \n",
       "15   4725x1802x1478      吉利   帝豪GL        4  \n",
       "16   4725x1802x1478      吉利   帝豪GL        4  \n",
       "17   4956x1861x1513      吉利     博瑞        3  \n",
       "18   4725x1802x1478      吉利   帝豪GL        2  \n",
       "19   4725x1802x1478      吉利   帝豪GL        2  \n",
       "20   4725x1802x1478      吉利   帝豪GL        2  \n",
       "21   4725x1802x1478      吉利   帝豪GL        2  \n",
       "22   4725x1802x1478      吉利   帝豪GL        2  \n",
       "23   4725x1802x1478      吉利   帝豪GL        2  \n",
       "24   4725x1802x1478      吉利   帝豪GL        2  \n",
       "25   4725x1802x1478      吉利   帝豪GL        2  \n",
       "26   4005x1760x1575      吉利   远景X3        3  \n",
       "27   4005x1760x1575      吉利   远景X3        3  \n",
       "28   4599x1747x1482      吉利     远景        4  \n",
       "29   4599x1747x1482      吉利     远景        4  \n",
       "..              ...     ...    ...      ...  \n",
       "664  4519x1831x1694      吉利     博越        3  \n",
       "665  4519x1831x1694      吉利     博越        3  \n",
       "666  4519x1831x1694      吉利     博越        3  \n",
       "667  4519x1831x1694      吉利     博越        3  \n",
       "668  4519x1831x1694      吉利     博越        6  \n",
       "669  4519x1831x1694      吉利     博越        6  \n",
       "670  4519x1831x1694      吉利     博越        6  \n",
       "671  4519x1831x1694      吉利     博越        6  \n",
       "672  4519x1831x1694      吉利     博越        5  \n",
       "673  4519x1831x1694      吉利     博越        5  \n",
       "674  4519x1831x1694      吉利     博越        5  \n",
       "675  4519x1831x1694      吉利     博越        5  \n",
       "676  4519x1831x1694      吉利     博越        5  \n",
       "677  4512x1857x1673      领克   领克01        4  \n",
       "678  4500x1834x1707      吉利  远景SUV        3  \n",
       "679  4500x1834x1707      吉利  远景SUV        3  \n",
       "680  4500x1834x1707      吉利  远景SUV        3  \n",
       "681  4500x1834x1707      吉利  远景SUV        3  \n",
       "682  4500x1834x1707      吉利  远景SUV        3  \n",
       "683  4500x1834x1707      吉利  远景SUV        3  \n",
       "684  4500x1834x1707      吉利  远景SUV        3  \n",
       "685  4500x1834x1707      吉利  远景SUV        3  \n",
       "686  4519x1831x1694      吉利     博越        4  \n",
       "687  4519x1831x1694      吉利     博越        4  \n",
       "688  4519x1831x1694      吉利     博越        4  \n",
       "689  4519x1831x1694      吉利     博越        4  \n",
       "690  4519x1831x1694      吉利     博越        4  \n",
       "691  4844x1884x1762      吉利  豪情SUV        3  \n",
       "692  4844x1884x1762      吉利  豪情SUV        3  \n",
       "693  4844x1884x1762      吉利  豪情SUV        3  \n",
       "\n",
       "[694 rows x 17 columns]"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "LSG_price['curb_weight'] =LSG_price['整备质量[kg]']\n",
    "LSG_price = LSG_price.groupby(['轴距[mm]','长×宽×高[mm]','brand','curb_weight','style'])['factory'].count().reset_index()\n",
    "LSG_price['car_length'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[0])\n",
    "LSG_price['car_width'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[1])\n",
    "LSG_price['car_height'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[2])\n",
    "LSG_price['Wheelbase'] =LSG_price['轴距[mm]']\n",
    "\n",
    "LSG.merge(LSG_price,on=['car_length','car_width','car_height','Wheelbase','curb_weight'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [],
   "source": [
    "result = LSG.merge(LSG_price,on=['car_length','car_width','car_height','Wheelbase','curb_weight'])\n",
    "import re\n",
    "vin1 = []\n",
    "for a,i in result.iterrows():\n",
    "    a = re.findall(r'L[0-9A-Za-z]{7}×××××××××',i['vin'])\n",
    "    for j in a:\n",
    "        vin = []\n",
    "        vin.append(j)\n",
    "        vin.append(i['car_factory'].split(',')[0])\n",
    "        vin.append(i['brand_y'].split(',')[0])\n",
    "        vin.append(i['style'].split(',')[0])\n",
    "        vin1.append(vin)\n",
    "vin = pd.DataFrame(vin1,columns=['vin','car_factory','brand','style'])\n",
    "vin = vin.drop_duplicates()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [],
   "source": [
    "vin.to_csv('吉利_VIN.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
